/*
 Navicat Premium Data Transfer

 Source Server         : 本机MySQL
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : area

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 06/03/2021 16:06:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for area_table
-- ----------------------------
DROP TABLE IF EXISTS `area_table`;
CREATE TABLE `area_table` (
  `store_id` varchar(10) NOT NULL COMMENT '店铺id',
  `area` varchar(20) DEFAULT NULL COMMENT '店铺位置',
  `leader_id` int(11) DEFAULT NULL COMMENT '店长id',
  PRIMARY KEY (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of area_table
-- ----------------------------
BEGIN;
INSERT INTO `area_table` VALUES ('store1', 'alpha', 139844);
INSERT INTO `area_table` VALUES ('store10', 'beta', 269966);
INSERT INTO `area_table` VALUES ('store11', 'beta', 442066);
INSERT INTO `area_table` VALUES ('store12', 'gamma', 52404);
INSERT INTO `area_table` VALUES ('store13', 'gamma', 250697);
INSERT INTO `area_table` VALUES ('store14', 'gamma', 733530);
INSERT INTO `area_table` VALUES ('store15', 'gamma', 356103);
INSERT INTO `area_table` VALUES ('store16', 'gamma', 770287);
INSERT INTO `area_table` VALUES ('store2', 'alpha', 44311);
INSERT INTO `area_table` VALUES ('store3', 'alpha', 951837);
INSERT INTO `area_table` VALUES ('store4', 'alpha', 298987);
INSERT INTO `area_table` VALUES ('store5', 'beta', 774548);
INSERT INTO `area_table` VALUES ('store6', 'beta', 974663);
INSERT INTO `area_table` VALUES ('store7', 'beta', 550242);
INSERT INTO `area_table` VALUES ('store8', 'beta', 735906);
INSERT INTO `area_table` VALUES ('store9', 'beta', 813931);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
